microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 26

How many worksheets can a workbook have?

a) 3

b) 8

c) 255

d) All of above

e) None of these

Answer: (d)

Question : 27

Which area In an Excel window allows entering values and formulas?

a) Title Bar

b) Menu Bar

c) Formula Bar

d) Standard Tool Bar

e) None of these

Answer: (c)

Question : 28

In Excel to view a cell comment

a) Click the edit comment command on the insert menu

b) Click the display comment command on the window menu

c) Position the mouse pointer over the cell

d) Click the comment command on the view menu

Answer: (c)

Question : 29

A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button......

a) nothing will print because some cells with data have been omitted

b) only the cells with gray back-ground will print

c) the whole sheet will print

d) only the cells with white background will print

e) None of these

Answer: (d)

Question : 30

In Excel what does SUMIF function do?

a) Adds up cell values based on a condition

b) Adds all the numbers in a range of cells

c) Returns a subtotal in a list or database

d) All of above

Answer: (a)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 11 Online Quiz

Click to Start..
417 microsoft excel qa based computer MCQ MS excel set 11 question answer with explanation pdf

Recently Added Subject & Categories For All Competitive Exams

100+ Quadratic Equation Questions Answers PDF for Bank

Quadratic Equation multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

IBPS Aptitude Linear Equations MCQ Questions Answers PDF

Linear equations multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

New 100+ Compound Interest MCQ with Answers PDF for IBPS

Compound Interest verbal ability questions and answers solutions with PDF for IBPS RRB PO. Aptitude Objective MCQ Practice Exercises all competitive exams

02-Jul-2024 by Careericons

Continue Reading »

100+ Mixture and Alligation MCQ Questions PDF for IBPS

Most importantly Mixture and Alligation multiple choice questions and answers with PDF for IBPS RRB PO. Aptitude MCQ Practice Exercises all Bank Exams

02-Jul-2024 by Careericons

Continue Reading »